Setting up SQL Server for CSense access

This section describes the SQL Server configuration required for all Windows user accounts on a CSense Data Server.

You are required to configure additional user accounts (user accounts other than the installing user account) and custom service accounts on the target SQL Server instance where the CSense Data Server is installed.

Identify your license type for your Application Server and follow the instructions below to setup the Windows User account for SQL access.

Required user accounts and privileges

The table below describes the privileges needed for the SQL Server logins and Windows logins needed for each user account for CSense. This includes users of the CSense applications and Windows accounts specified during installation for the CSense services. “User Account” is a generic term that satisfy the following conditions:

Can log in to Windows
The Windows login is mapped to a SQL Server login that has the public Server Role assigned.

“User Account” can be implemented using individual user accounts or groups, either on the local machine or on an Active Directory Domain level.

CSense Troubleshooter Licenses

Windows Privileges	SQL Server Database	SQL Server Database Roles for CSense Users	Database Roles for CSense Service accounts
User	CSenseRecipes	csense_cache	NA
	CSense	csense_troubleshooter	NA

CSense Runtime Licenses

Windows Privileges	SQL Server Database	SQL Server Database Roles for CSense Users	Database Roles for CSense Service accounts
Local Machine Administrator	CSenseRuntime	csense_cache csense_admin	csense_execute
	CSense	csense_admin csense_troubleshooter	csense_execute
	CSenseCache	csense_admin	csense_execute

CSense Developer Licenses

Windows Privileges	SQL Server Database	SQL Server Database Roles for CSense Users	Database Roles for CSense Service accounts
Local Machine Administrator	CSenseRecipes	csense_cache	NA
	CSenseRuntime	csense_cache csense_admin	csense_execute
	CSense	csense_admin csense_troubleshooter	csense_execute
	CSenseCache	csense_admin	csense_execute

Setting up Windows user accounts on the CSense Data Server

Identify the Windows user account.

NOTE: Users of the CSense applications and the Windows accounts for CSense services may differ as specified during installation. Be sure to include both types of user accounts when setting up database users and roles.
Create a SQL Server login for the Windows user account on the target instance of SQL Server where the CSense Data Server is located.
Ensure that the created SQL Server Login has at least the public server role assigned.
Create a database user on the relevant database as described in the tables above (Note your license type).
Map the created database user to the SQL Server login you created.
Assign the correct database roles to the database user as specified in the tables above (Note your license type).